Skip to main content

enq: TC - contention

Short Description

Enqueue wait. Thread Checkpoint.

Additional Information​

An enqueue is a wait for a resource held by another.

enq: TC - contention is seen during checkpoint operation. They can be seen during traditional hot backup operations or associated with parallel queries.

How to reduce this wait​

Check for a large amount of dirty buffers in the buffer cache, or for parallel query threads updating where PGA buffers are dirty.

Oracle Docs - Oracle Enqueue Names

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.